﻿<?xml version="1.0"?>
<ConfigList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Lists>
    
    <ListInfo  ListKey="SqlConfig" ListDesc="页面sql语句">
      <Items>
        <!--查看所有记录-->
        <ItemInfo name="SelectByDate" value="SELECT
      [USERNAME]
      ,[Gender]
      ,[EMAIL]
      ,[CarTypeID] 
      ,[Source] 
      ,[channel]
      ,[campaign]
      ,[LanguageType]
      ,[TechType]
      ,case when [DataType]='1' then '是' else '否' end as 'datatype'
      ,[Register_TIME] 
      ,[Remark] 
      FROM vw_demand_info
      where Register_TIME&gt;='[$StartTime] 00:00:00' and Register_Time&lt;='[$EndTime] 23:59:59' [$where] order by CustomerID desc
           "/>
     

      </Items>
      
      
      
    </ListInfo>

 
  </Lists>
</ConfigList>
